Port Bug Report: pg_dump does incorrect save of permissions in 6.4 - Mailing list pgsql-ports

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Henry B. Hotz
Your email address      : hotz@jpl.nasa.gov

Category                : runtime: back-end
Severity                : serious

Summary: calling notify in pl/pgsql proc causes core dump

System Configuration
--------------------
  Operating System   : Solaris 2.5

  PostgreSQL version : 6.4

  Compiler used      : gcc 2.7.2.2

Hardware:
---------
SPARCstation 5

Versions of other tools:
------------------------
N/A

--------------------------------------------------------------------------

Problem Description:
--------------------
pg_dump -z creates grant commands of the form
grant "all" on "hotz" to "hotz";
instead of
grant "all" on "table" to "hotz";

Don't know if this is fixed in newer dot revisions or 6.5.

--------------------------------------------------------------------------

Test Case:
----------
pg_dump -z <database> >db.backup

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------

Signature failed Preliminary Design Review.
Feasibility of a new signature is currently being evaluated.
h.b.hotz@jpl.nasa.gov, or hbhotz@oxy.edu